Topics
Started by
Posts
Last post
Hello All, Could any of you please let me know why the row_number paging function is having a perfo…
4 replies
under active monitor, I found there was very amount of cumulative wait time(sec) for Lock, now I w…
4 replies
Hi I have a table which I would like to turn columns into rows. create table Customer ( CIDint …
4 replies
Hi I have a table as below, with example data in it ID Name 2346 M Smith 2346 …
11 replies
I am at a wall with this. I thought it was going to be easy but clearly I am missing something. Th…
5 replies
we can use the folloiwng sql statment to monitor the statement executed before, but we can use th…
5 replies
I am a developper who at times in my career had to fill the accidental dba role as well; and I hav…
3 replies
in a stored procedure, I found two line sql scripts " if @@microsoftversion > 0x07320000 exec…
2 replies
Usually, we often talk about the approach of optimization select statement in SQL server, but now i…
6 replies
I used SQL profile to trace SQL Statement and found user use insert bulk to insert data for a table…
7 replies
This summer I authored a report that referenced nine tables in a query. This is against an older da…
2 replies
There is an Itemcode field with char(15) in a table named ItemInfo, it has 200 million pieces of re…
4 replies
Hi gurus! I am trying to use the try_convert function on a SQL Server 2014 Standard Edition and a S…
2 replies
If my column contains these values. C:\AABCD\EDFG\RFG\MyDB123.bak D:\RFG\MyDB1123.bak E:\AABCD\EDFG…
2 replies
@Grant Fletcher and @Michael L John. As suggested I looked up the backupset tables and I think we c…
18 replies
Viewing 15 topics - 271 through 285 (of 3,067 total)
You must be logged in to create new topics.