Topics
Started by
Posts
Last post
What is the impact on the users to drop an index on a table while in use? I will recreate the inde…
3 replies
Hi I have 3 tables , Customer , Sales Cost Charge and Sales Price , i have join the customer table…
4 replies
We're in the process of investigating the implementation of SQL Server 2012 across our infrastructu…
15 replies
I had a database in suspect mode this morning. Fixed it by: -placing in emergency mode. -set single…
12 replies
I know you can't restore a database which is SQL 2012 compatibility mode to a SQL 2005 instance, bu…
3 replies
The SQL CAT team's recommendation is to avoid partitioning dimension tables: http://blogs.msdn.com/…
7 replies
Hi, Have been reading articles on tuning queries and commonly come across the set statistics io/ti…
7 replies
Hi, Thanks in advance. We have a SQL Server 2012 two node cluster on Windows 2008 R2. Now we were a…
1 replies
Hi, If one is regularly taking backups of system databases, when does it become necessary to rebuil…
1 replies
DECLARE @tab char(1) = CHAR(9) DECLARE @Localquery VARCHAR(MAX) SET @Localquery = 'SELECT SOME ST…
5 replies
Hello, I have a strange problem SQL, and I am spoiled by SQLs (usually) great logging and error rep…
10 replies
One purchased app stored user's multiple lines input into a varchar column in which including char(…
5 replies
Below dynamic sql giving me an error Incorrect syntax near '.'. Please help me for this issue. I am…
15 replies
Hi, In my ETL job I would like to truncate stg table but before truncating stging table, I want to …
2 replies
Just installed 2012 and wanted to set query text font to fixedsys but could not find it in drop-dow…
1 replies
Viewing 15 topics - 6,496 through 6,510 (of 8,627 total)
You must be logged in to create new topics.