mssqlinterview.blogspot.com
SQL Server Interview Questions and answers
SQL Server Interview Questions and answers. A complete collection of Sql server Interview Questions,sql server performance,stored procedure, trigger,Sql query,security,ms sql server 2005,database backup,restore,free ebook,tutorials. Jun 13, 2012. How to pass a list of values or array to SQL Server stored procedure? CREATE PROC dbo.GetOrderList1. SELECT OrderID, CustomerID, EmployeeID, OrderDate. WHERE OrderID IN (' @OrderList ')'. GRANT EXEC ON dbo.GetOrderList1 TO WebUser. Aug 24, 2008. Both are the sam...
mssqlmistake.blogspot.com
MSSQL Mistake
Friday, March 30, 2012. I just created a report with 2 parameters and it works fine. If I change one of them to MV it still works but if I pick 2 values I get a message about a problem with the , - Incorrect syntas near ','. Is this a known problem or is it something I'm doing. Is a problem is there a fix for it. YOu habe to change your query after changing the parameter type, as your query probably look like. WHERE SomeColumn = @.MyParameter. Which will evaluate in a MV-Parameter to. HTH, Jens Suessmeyer.
mssqlnotes.com
MSSQLNOTES | A world of SQL notes
A world of SQL notes. 10 June 2014, 5:54 pm. As SQL Server DBA I sometimes face the problem of not being able to reduce the file size of certain database transaction log even after making a log backup therefor being truncated . First of all just highlight that if not strictly necessary shrinking the transaction log is not recommended, why? The following description for the four VLF status are from the “Microsoft SQL Server 2008 Internals” :. Finally let s find some TSQL scripts that most likely will shri...
mssqlnotes.es
MSSQLNOTES | A world of SQL notes
A world of SQL notes. 10 June 2014, 5:54 pm. As SQL Server DBA I sometimes face the problem of not being able to reduce the file size of certain database transaction log even after making a log backup therefor being truncated . First of all just highlight that if not strictly necessary shrinking the transaction log is not recommended, why? The following description for the four VLF status are from the “Microsoft SQL Server 2008 Internals” :. Finally let s find some TSQL scripts that most likely will shri...
mssqlonline.blogspot.com
mssqlonline
Subscribe to: Posts (Atom). View my complete profile. Watermark theme. Powered by Blogger.
mssqlonline.com
MSSQLONLINE.com | SQL Server Tips, Tricks, and Info
SQL Server Tips, Tricks, and Info. SQL Server Exam Tips. Exam 70-461:Querying MSSQL Server 2012. Exam 70-462: Administering Microsoft SQL Server 2012 Databases. Exam 70-463:Implementing a Data Warehouse with Microsoft SQL Server 2012. DBCC CHECKDB – Use and Abuse. I recently got asked this question by one of my clients:. 8220;I get an error in the logs indicating that I have a torn page or checksum error. What do I do? Should I run DBCC CHECKDB with one of the repair options! So How Do I Use It? You migh...
mssqlonline.wordpress.com
Ms-sql online | Ms-sql online műveletek + optimalizáció
Ms-sql online műveletek optimalizáció. Amikor a memóriára várunk. Talán mindenki tudja, ha adatbázis kiszolgáló a szerver, akkor legyen minél több a memória benne. Ezt én is osztom, hiszen a memória olcsó befektetés és látványos javulás érhető el vele. Mielőtt tovább mennék nézzük meg, miért is olyan fontos a sok memória. Erre az esetre (is) alkottak az SQL Server fejlesztői két nagyszerű nézetet, amivel ez a hiba elég jól beazonosítható:. Sysdm exec query resource semaphores. 6 lekérdezés fog következni:.
mssqlonlinetraining.blogspot.com
MS SQL Online Training
MS SQL Online Training. SQL Training in Bangalore, MSSQL Query Writers, SQL Query Writers, SQL Server 2012 Query Writers, SQL Server Query Writers, SQL Server Performance Tuning Training, SQL Performance Tuning Training, SQL Server Online Training In Bangalore, SQL Server 2008 Training, SQL Server 2008 Administration Training, SQL Server 2008 Administrator Training, SQL Server 2012 Online Training. SQL Server 2012 for Administrators. Sample Live Projects are provided. 103/10, 60 Feet Road, JaiBheem Nagar,.
mssqlperformance.blogspot.com
SQL Server Performance
Performance tips for beginner through guru programmers and DBAs using Microsoft SQL Server. Wednesday, April 13, 2016. Unused indexes - updated script. Database Name] [nvarchar] (. Object Name] [nvarchar] (. Index Name] [sysname] NULL,. Drop Statement] [nvarchar] (. User seeks] [bigint] NULL,. User scans] [bigint] NULL,. User lookups] [bigint] NULL,. INSERT INTO tempdb.TempIndexDrop select db name(database id) as ' Database Name' , object name(i.object id) as ' Object Name' ,. Where database id = db id('?
mssqlpro.com
MS SQL Server Programmer
MS SQL Server Programmer. I'm a Microsoft SQL Server expert programmer with over a dozen years of experience with the product. I design custom applications for small and mid-sized companies that want to upgrade from other platforms such as Excel and Access to take advantage of SQL's enterprise features. Microsoft Access Database Developer. Microsoft Access Database Programming. MS Access Database Developer. MS Access Database Programming. Microsoft Access Database Expert. MS Access Database Expert. MS Ac...
