Viewing 15 posts - 5,536 through 5,550 (of 8,761 total)
This shouldn't be too hard, can you post the DDL for the table and the data as an insert statement?
😎
April 23, 2015 at 2:21 am
GilaMonster (4/23/2015)
https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
Thanks Gail
😎
April 23, 2015 at 2:20 am
Slightly improved version
😎
USE master;
GO
SELECT TOP 20
ISNULL(DB_NAME(st.dbid),N'N/A') AS DATABASE_NAME
...
April 23, 2015 at 1:35 am
gfx99ne (4/22/2015)
pietlinden (4/22/2015)
T-SQL does all the data manipulation
VBA does the front end stuff.
Unless you have to do automation of some kind in VBA that cannot be...
April 22, 2015 at 11:23 pm
SQL Guy 1 (4/22/2015)
I am monitoring our production server, and noticed that periodically we have spikes of Memory Paging Rate (pages/sec).How to find particular queries/stored procedures that causing this?
Thanks
Quick...
April 22, 2015 at 11:18 pm
WhiteLotus (4/22/2015)
Hi All,How do I find out top expensive queries from SQL Server 2008 – Standard edition ?
Thank you
Cheers
Query the sys.dm_exec_query_stats
😎
April 22, 2015 at 11:14 pm
ngustafson-1056093 (4/22/2015)
April 22, 2015 at 11:11 pm
djj (4/22/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
fecal fabric flinging fairiesPixie Dust
Neverland
Dragons
April 22, 2015 at 4:55 am
Welsh Corgi (4/21/2015)
Eirikur Eiriksson (4/21/2015)
Welsh Corgi (4/21/2015)
I need the 32bit and 64bit for the Administrative installation
I did a search but I do not think they are the correct downloads.
Do I...
April 22, 2015 at 1:39 am
rhythmk (4/21/2015)
April 22, 2015 at 1:18 am
SQLRNNR (4/21/2015)
fecal fabric flinging fairies
Pixie Dust
April 21, 2015 at 10:35 pm
Ed Wagner (4/21/2015)
TomThomson (4/21/2015)
Ed Wagner (4/21/2015)
Eirikur Eiriksson (4/21/2015)
Ed Wagner (4/21/2015)
crookj (4/21/2015)
TomThomson (4/21/2015)
Revenant (4/21/2015)
djj (4/21/2015)
Ed Wagner (4/21/2015)
eccentricDBA (4/21/2015)
Eirikur Eiriksson (4/21/2015)
Ed Wagner (4/21/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
faintdistant
Far
Fetched
idea
Start
Finish
Line
Dance
Disco
Dead
Beat
Rhythm
Blues
Barbeque
Bite
April 21, 2015 at 2:04 pm
Ed Wagner (4/21/2015)
crookj (4/21/2015)
TomThomson (4/21/2015)
Revenant (4/21/2015)
djj (4/21/2015)
Ed Wagner (4/21/2015)
eccentricDBA (4/21/2015)
Eirikur Eiriksson (4/21/2015)
Ed Wagner (4/21/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
faintdistant
Far
Fetched
idea
Start
Finish
Line
Dance
Disco
Dead
Beat
April 21, 2015 at 12:33 pm
SDG1 (4/20/2015)
"A SQL Server update with a higher version has already been installed on...
April 21, 2015 at 12:16 pm
Welsh Corgi (4/21/2015)
I need the 32bit and 64bit for the Administrative installation
I did a search but I do not think they are the correct downloads.
Do I have to go through...
April 21, 2015 at 12:12 pm
Viewing 15 posts - 5,536 through 5,550 (of 8,761 total)