Viewing 15 topics - 29,041 through 29,055 (of 284,191 total)
Topics
Started by
Posts
Last post
I currently move data from an Oracle 11g DW to SQL Server 2016 by scripting SQLPlus (flat file out)…
2 replies
Hello, I have a tab cube, with a dimension key column I'd like to get a distinct count on with a si…
5 replies
Hi All, For tuning poorly performing query on a Testing server or local SQL instance on a Laptopn, …
2 replies
Folks, I am (trying to) create an XML data file from SQL that has the following structure<Letter…
1 replies
Hi Guys, Can someone please help me get the results from query 1 into query 2 (IE a count case when…
5 replies
Dear Experts,Please advise how I can script all the tables of a database with ALTER option . It sho…
2 replies
Hi All, Need some guidelines when considering creating a missing index. When I get information fr…
5 replies
Hi All, Need Index suggestion. I am seeing on one of our prod table, I see 18 non-clustered indexes…
3 replies
Comments posted to this topic are about the item Grouping
3 replies
HI, I got this from the ola.hallengren web site and when I run it, it doesn't appear to do any…
9 replies
Hi friends, I have one stored procedure Test_db_list it ll display result depends on date range i h…
2 replies
IF OBJECT_ID('Tempdb..#tStudents') IS NOT NULLDROP TABLE #tStudents CREATE TABLE #tStudents( &…
8 replies
Hi, I'm trying to build a process using SQL agent, and CmdExec to call a batch file. However whene…
1 replies
I currently use the expressions: =today.adddays(1-today.day) =Today.AddDays(1-Today.Day).AddM…
4 replies
Hello, Does anyone know what the following Spinlocks stand for? name co…
10 replies
Viewing 15 topics - 29,041 through 29,055 (of 284,191 total)