Viewing 15 posts - 5,521 through 5,535 (of 8,753 total)
What is the world coming to, this one posted the skype but forgot the Credit Card Number 😀
😎
April 24, 2015 at 1:39 am
ngochoang297 (4/24/2015)
Eirikur Eiriksson (4/24/2015)
ngochoang297 (4/23/2015)
Pls, tell me, How i can find XML Document :). I install SQL 2008 r2, when "ready to install' step, it showes Error Message.
My bad, I...
April 24, 2015 at 1:35 am
Quick solution that should get you passed this hurdle, some comments in the code.
😎
USE tempdb;
GO
SET NOCOUNT ON;
/* XML variable for the elements to insert */
DECLARE @XML_INSERT XML = NULL;
/* Parent...
April 24, 2015 at 1:19 am
ngochoang297 (4/23/2015)
Pls, tell me, How i can find XML Document :). I install SQL 2008 r2, when "ready to install' step, it showes Error Message.
My bad, I misread the OP,...
April 24, 2015 at 12:44 am
ngochoang297 (4/23/2015)
TITLE: SQL Server Setup failure.
------------------------------
SQL Server Setup has encountered the following error:
There was an error generating the...
April 23, 2015 at 11:10 pm
Ed Wagner (4/23/2015)
crookj (4/23/2015)
Ed Wagner (4/23/2015)
Revenant (4/23/2015)
djj (4/23/2015)
Eirikur Eiriksson (4/23/2015)
Ed Wagner (4/23/2015)
djj (4/23/2015)
TomThomson (4/22/2015)
Eirikur Eiriksson (4/22/2015)
djj (4/22/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
fecal fabric flinging fairiesPixie Dust
Neverland
Dragons
Dungeons
Master
Game
Theory
Relativity
Time
Travel
4th
Wormhole
Service pack
April 23, 2015 at 3:32 pm
Ed Wagner (4/23/2015)
djj (4/23/2015)
TomThomson (4/22/2015)
Eirikur Eiriksson (4/22/2015)
djj (4/22/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
fecal fabric flinging fairiesPixie Dust
Neverland
Dragons
Dungeons
Master
Game
Theory
April 23, 2015 at 5:51 am
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
Viewing 15 posts - 5,521 through 5,535 (of 8,753 total)