Topics
Started by
Posts
Last post
I've not even considered partitioning something like a temporal audit table (INSERTs only, never an…
2 replies
Hello all. I am going to request that our hosting and development company create a back up of one o…
2 replies
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
Viewing 15 topics - 6,496 through 6,510 (of 8,629 total)
You must be logged in to create new topics.